﻿<cfsilent>
	<cfscript>
		
		propertyAdvice = getProperty("serviceFactory").getBean("studentPropertyAdvice");
		markAdvice = getProperty("serviceFactory").getBean("markAdvice");
		
		event.setArg("pageTitle", "本科生管理 - 毕业审核");
		
		studentId = event.getArg("stu");
		
		
		passArgs = structNew();
		
		currentTab = event.getArg("TabID", "labSearch");
		
	
		/* 搜索学生档案 */
		cases = event.getArg("cases");
		HSQL = "";
		keyword = trim(event.getArg("Keywords")) ;
		
		if( cases eq "" OR cases eq "1"){
			cases = "1";
			keyword = ucase(keyword);
			HSQL = "upper( ";
		}else if( cases eq "2"){
			keyword = lcase(keyword);
			HSQL = "Lower( ";
		}else{
			HSQL = "(";
		}
		
		structInsert(passArgs,"cases", cases );
		

		rs_student = queryNew("stu_id");
		
		if ( len(keyword) ) {
			
			
			sql = "SELECT 
						 " & HSQL & " t_student.stu_id ) stu_id,
						 " & HSQL & " t_student.stu_name_english ) stu_name_english, 
						 " & HSQL & " t_student.NATIONALITY ) NATIONALITY, 
						 " & HSQL & " t_student.stu_idcard ) stu_idcard, 
						 " & HSQL & " t_student.stu_name ) stu_name, 
						 " & HSQL & " t_student.stu_sex ) stu_sex, 
						 t_student_status.student_prop,
						 (SELECT tch_name FROM t_teacher where t_teacher.tch_id = t_student.tch_id) tch_name 
					FROM 
						 t_student 
						 INNER JOIN t_student_status ON t_student_status.stu_id = t_student.stu_id 
					WHERE 
						 (
							 " & HSQL & " t_student.stu_id ) LIKE :condition 
							 OR 
							 " & HSQL & " t_student.stu_name ) LIKE :condition 
							 OR 
							 " & HSQL & " t_student.stu_name_english ) LIKE :condition 
							 or 
							 " & HSQL & " T_STUDENT.stu_idcard ) LIKE :condition 
							 OR 
							 " & HSQL & " t_student.NATIONALITY ) like :condition 
						 )
						 AND 
						 (t_student_status.st_id = '8' OR t_student_status.st_id = '83' )
					ORDER BY 
						 t_student.stu_name ";
			
			queryObj = new Query( datasource=application.dnsSlave, maxRows=30 );
			queryObj.addParam( name="condition", value="%"&keyword&"%", cfsqltype="cf_sql_varchar" );
			
			rs_student = queryObj.execute( sql=sql ).getResult();
	
						
		}
		
		rs_studentEntity = queryNew("stu_id");
		rs_teacher = queryNew("tch_id");
		
		if ( len(studentId) ) {
			
			currentTab = event.getArg("TabID", "labForm");
			
			
			/*学生信息*/
			sql = "SELECT a.stu_id,a.stu_name,a.stu_name_english,a.stu_sex, a.nationality,a.STU_BIRTHDAY, 
					  b.hsk_score, b.date_join,b.stu_id, b.st_id, c.name  
					FROM t_student a 
					INNER JOIN t_student_status b ON b.stu_id = a.stu_id 
					INNER JOIN i_code_info c ON c.code_id = b.st_id 
					WHERE a.stu_id = :studentId";
			
			queryObj = new Query( datasource=application.dnsSlave );
			
			queryObj.addParam( name="studentId", value=studentId, cfsqltype="cf_sql_varchar" );
	
			rs_studentEntity = queryObj.execute( sql=sql ).getResult();
			
			
			dateJoin = "";
		
			tipDate = "";
			
			/*如果没有入学时间，那么把入学时间设为第一个班级的时间*/	
			
			dateJoinContent = rs_studentEntity.date_join;
			
			if( rs_studentEntity.date_join eq ''){
				
				sql = "select grade from (select grade from t_class where cls_id in (select cls_id from i_stu_class_info a where a.stu_id = :studentId ) order by grade ) where rownum = 1";	
				queryObj = new Query( datasource=application.dnsSlave );
			
				queryObj.addParam( name="studentId", value=studentId, cfsqltype="cf_sql_varchar" );
		
				rs_class = queryObj.execute( sql=sql ).getResult();
				
				if( rs_class.recordCount gt 0){
					
					if( right(rs_class.grade,1) eq '1' ){
						dateJoin = left(rs_class.grade,4) & "0901";
						dateJoinContent = left(rs_class.grade,4) & "-09-01";
					}else{
						dateJoin = (left(rs_class.grade,4)+1) & "0301";
						dateJoinContent = left(rs_class.grade,4) & "-03-01";
					}
					
					tipDate = dateJoin;
				}
	
				
			}else{
				dateJoin = replace(rs_studentEntity.date_join,'-','','ALL');
				dateJoin = replace(dateJoin,',','','ALL');
				dateJoin = replace(dateJoin,'.','','ALL');
			}
			
			stuYear = "0";
		
			/*根据入学时间判断学生类型和免修课程*/
			if( left(dateJoin,6) < 200808 ){
				stuYear = "2005";	
			}else if( left(dateJoin,6) < 201208 ){
				stuYear = "2008";	
			}else if( left(dateJoin,6) < 201308 ){
				stuYear = "2012";	
			}else if( left(dateJoin,6) >= 201308 ){
				stuYear = "2013";	
			}	
			
			/*成绩信息*/
			sql = "SELECT 
						a.mark_mode,a.mark_result,a.mark_note,a.mark_resit,a.mark_renote,a.mark_resit_limit,
						a.credit, a.credit_point, a.credit_point_o, a.exam_module, a.cid , 
						a.prop_id,a.term_id, 
						b.course_code,b.course_name,
						(SELECT t.name FROM t_course_type s INNER JOIN t_course_type_dict t ON t.id = s.course_dict
						 WHERE (s.course_code = b.course_code OR b.course_name like s.course_name || '%' ) AND s.year = :year AND rownum=1
						) course_type ,
						(SELECT t.rank FROM t_course_type s INNER JOIN t_course_type_dict t ON t.id = s.course_dict
						 WHERE (s.course_code = b.course_code OR b.course_name like s.course_name || '%' ) AND s.year = :year AND rownum=1
						) course_rank 
					 FROM t_student_mark a 
					 INNER JOIN t_course b ON b.cid = a.cid 
					 WHERE a.stu_id = :studentId 
					 ORDER BY prop_id, course_rank,  course_code ";
					 
			queryObj = new Query( datasource=application.dnsSlave );
			
			queryObj.addParam( name="studentId", value=studentId, cfsqltype="cf_sql_varchar" );
			queryObj.addParam( name="year", value=stuYear, cfsqltype="cf_sql_char" );
	
			rs_studentMark = queryObj.execute( sql=sql ).getResult();
			
			cids = "";
			courseNames = "";
			
			for( i=1; i LE rs_studentMark.recordCount ;i++){
				
				if( rs_studentMark["credit"][i] neq '0'){
					
					cids = cids & rs_studentMark["cid"][i] & ",";
					courseNames = courseNames & rs_studentMark["course_name"][i] & ",";
					
				}
				
			}
			
				
			yearTerm = left(dateJoin,6);
			
			yearMouth = "";
			
			if(yearTerm lt 200808){
				yearMouth = '200508';
			}else if(yearTerm lt 201208){
				yearMouth = '200808';
			}else if(yearTerm lt 201308){
				yearMouth = '201208';
			}else{
				yearMouth = '201308';
			}
			
			/*HSK免修成绩信息*/
			sql = "SELECT a.course_name, a.course_code, a.cid, a.credit, a.course_credit, b.prop_id ,  
						(SELECT t.name FROM t_course_type s INNER JOIN t_course_type_dict t ON t.id = s.course_dict
						 WHERE (s.course_code = a.course_code or b.course_name like s.course_name || '%') AND s.year = :year and rownum=1 
						) course_type ,
						(SELECT t.rank FROM t_course_type s INNER JOIN t_course_type_dict t ON t.id = s.course_dict
						 WHERE (s.course_code = b.course_code OR b.course_name like s.course_name || '%' ) AND s.year = :year AND rownum=1
						) course_rank 
				   FROM t_hsk_course a 
				   INNER JOIN t_course b ON b.cid = a.cid 
				   WHERE a.hsk = :hskScore 
					    AND 
					    a.year_term = :yearMouth 
					    AND a.course_name NOT IN (:names) 
					    AND a.cid NOT IN (:cids) 
				   ORDER BY 
					   a.course_name";
			
			queryObj = new Query( datasource=application.dnsSlave );
			
			queryObj.addParam( name="hskScore", value=rs_studentEntity.hsk_score, cfsqltype="cf_sql_varchar" );
			queryObj.addParam( name="yearMouth", value=yearMouth, cfsqltype="cf_sql_varchar" );
			queryObj.addParam( name="names", value=courseNames, cfsqltype="cf_sql_varchar", list=true );
			queryObj.addParam( name="cids", value=cids, cfsqltype="cf_sql_varchar", list=true );
			queryObj.addParam( name="year", value=stuYear, cfsqltype="cf_sql_char");
			
			rs_hskMark = queryObj.execute( sql=sql ).getResult();
			
			
			/*学年类别信息*/
			sql = "SELECT t.name,t.rank 
					FROM t_course_type s 
					INNER JOIN t_course_type_dict t ON t.id = s.course_dict
					WHERE s.year = :year 
					group by t.name,t.rank  
				   ORDER BY 
					   t.rank";
			
			queryObj = new Query( datasource=application.dnsSlave );
			
			queryObj.addParam( name="year", value=stuYear, cfsqltype="cf_sql_char");
			
			rs_courseType = queryObj.execute( sql=sql ).getResult();
			
			
			
			courseCredit = 0; //总学分
			courseMust = 0; //必修课学分
			courseSelect = 0; //选修课学分
			
			hasPrictice = "无";//是否有实习课程
			hasPaper = "无"; //是否有学士学位论文课程
			
			courseTypeTable = arrayNew(2);
			
			/*初始化课程类别学分*/
			for( j=1; j le rs_courseType.recordCount; j++ ){
				for( m=1;m<=2;m++){
					courseTypeTable[j][m] = 0;
				}
			}
			
			/*学分统计*/
			for( i=1; i LE rs_studentMark.recordCount ;i++){
				
				credit = rs_studentMark["credit"][i];
				
				/*对‘汉语阅读’按年级进行单独计算学分*/
				
				if( credit neq 0 ){
					
					 /*又松大学一律按2004级计划*/
					if( (stuYear eq '2008' and rs_studentEntity.st_id neq '83' )or stuYear eq '2012' ){
						if( (rs_studentMark["course_name"][i] eq '汉语阅读-1') or (rs_studentMark["course_name"][i] eq '汉语阅读-2') or (rs_studentMark["course_name"][i] eq '汉语阅读-3')){
							credit = 4;
						}
					}else{
						if( rs_studentMark["course_name"][i] eq '汉语阅读-1' ){
							credit = 3;
						}else if( (rs_studentMark["course_name"][i] eq '汉语阅读-2') OR (rs_studentMark["course_name"][i] eq '汉语阅读-3')){
							credit = 2;
						}
					}
					
				}
					
				
				courseCredit = courseCredit + credit;
				
				/*是否有实习课程*/
				if( rs_studentMark["course_name"][i] eq "实习"){
					
					hasPrictice = "不合格";
					if (credit neq 0){
						hasPrictice = "合格";
					}
				}
				
				/*是否有论文课程*/
				if( rs_studentMark["course_name"][i] eq "学士学位论文"){
					
					hasPaper = "不合格";
					if (credit neq 0){
						hasPaper = "合格";
					}
				}
				
				if( rs_studentMark["prop_id"][i] eq '1'){
					
					courseMust = courseMust + credit;
				}else{
					courseSelect = courseSelect + credit;
				}
				
				for( j=1; j le rs_courseType.recordCount; j++ ){
					
					if( rs_courseType["name"][j] eq rs_studentMark["course_type"][i]){
						
						if(rs_studentMark["prop_id"][i] eq '1'){
							courseTypeTable[j][1] = courseTypeTable[j][1] + credit;
						}else{
							courseTypeTable[j][2] = courseTypeTable[j][2] + credit;
						}
						
					}
					
				}
			}
			
			/*又松大学双学位不免修，不计算免修成绩*/
			if( rs_studentEntity.st_id neq '83'){
			
				/*课程类别免修学分统计*/
				for( i=1; i LE rs_hskMark.recordCount ;i++){
					
					courseCredit = courseCredit + rs_hskMark["course_credit"][i];
					
					if( rs_hskMark["prop_id"][i] eq '1'){
						courseMust = courseMust + rs_hskMark["course_credit"][i];
					}else{
						courseSelect = courseSelect + rs_hskMark["course_credit"][i];
					}
					
					for( j=1; j le rs_courseType.recordCount; j++ ){
						
						if( rs_courseType["name"][j] eq rs_hskMark["course_type"][i]){
							
							if(rs_hskMark["prop_id"][i] eq '1'){
								courseTypeTable[j][1] = courseTypeTable[j][1] + rs_hskMark["course_credit"][i];
							}else{
								courseTypeTable[j][2] = courseTypeTable[j][2] + rs_hskMark["course_credit"][i];
							}
							
						}
						
					}
				}
			
			}
			
			
			/*检查班级必修课是否修够*/
			/*韩国又松大学双学位*/
			if( rs_studentEntity.st_id eq '83'){
				
				/*查询学生所有班级*/
				sql = "SELECT a.cls_name, a.grade, a.cls_id FROM t_class a
					 where a.cls_id in (SELECT b.cls_id FROM i_stu_class_info b where b.stu_id = :studentId )";	
				
				queryObj = new Query( datasource=application.dnsSlave );
				
				queryObj.addParam( name="studentId", value=studentId, cfsqltype="cf_sql_varchar");
				
				rs_classes = queryObj.execute( sql=sql ).getResult();
				
				
				result = "";
				
				
				for( i=1; i lte rs_classes.recordCount; i++ ){
					
					/*班级课程*/
					sql = "select b.cid, b.course_name from t_task a 
						   INNER JOIN t_course b on b.cid = a.cid 
						   WHERE b.prop_id = '1' 
						   AND a.term_id = :termId 
						   AND a.task_classes like '%' || :className || '%'";
						   
					queryObj = new Query( datasource=application.dnsSlave );
				
					queryObj.addParam( name="termId", value=right(rs_classes["grade"][i],3), cfsqltype="cf_sql_char");
					queryObj.addParam( name="className", value=rs_classes["cls_name"][i], cfsqltype="cf_sql_varchar");
					
					rs_task = queryObj.execute( sql=sql ).getResult();
					
					if(rs_task.recordcount){
						
						for( j=1; j lte rs_task.recordCount; j++ ){
							
							/*班级课程*/
							sql = "select mark_result, mark_resit, mark_mode, mark_note, mark_renote 
									FROM t_student_mark 
									WHERE stu_id = :studentId AND cid = :courseId";
								   
							queryObj = new Query( datasource=application.dnsSlave );
						
							queryObj.addParam( name="studentId", value=studentId, cfsqltype="cf_sql_varchar");
							queryObj.addParam( name="courseId", value=rs_task["cid"][j], cfsqltype="cf_sql_varchar");
							
							rs_studentMark = queryObj.execute( sql=sql ).getResult();
							
							if( rs_studentMark.recordCount){
								
								if( max( rs_studentMark.mark_result, rs_studentMark.mark_resit ) lt 60 ){
									
									result = result & "|||" & rs_task["course_name"][j] & "(" & markAdvice.getMarkResult(rs_studentMark.mark_mode, rs_studentMark.mark_result, rs_studentMark.mark_note, rs_studentMark.mark_resit, rs_studentMark.mark_renote, '100') & ")";
									
								}
								
							}else{
								
								result = result & "|||" & rs_task["course_name"][j] & "(无)";
								
							}
							
						}
						
					}
				
				}
				
				
			}
			
		}

		
		
	</cfscript>
</cfsilent>

<div id="headArea">
	<div class="uiHeader uiHeaderWithImage ptm">
		<div class="clearfix uiHeaderTop">
			<div class="uiHeaderActions rfloat">
				<a class="uiButton" href="<cfoutput>#buildURL('DEFAULT_EVENT',passArgs)#</cfoutput>"><i class="mrs img btnPublish"></i><span class="uiButtonText">返回</span></a>
			</div>
			<div>
				<h2 class="uiHeaderTitle">
					<i class="uiHeaderImage img icon16x16 application"></i>本科生毕业审核
				</h2>
			</div>
		</div>
	</div>
</div>

<div class="UIElement">
	<ul class="senateFirstPage">
		<li>
			<div class="clearfix" id="summary">
				
				<div class="UItab">
					<div class="tabLables">
						<span <cfif currentTab eq "labSearch">class="active"</cfif> id="labSearch" tabTarget="Search">搜索本科生信息</span>
                              <cfif len(studentId)>
							<span <cfif currentTab eq "labForm">class="active"</cfif> id="labForm" tabTarget="Form">毕业汇总信息</span>
						</cfif>
					</div>
				</div>
				<script language="javascript" type="text/javascript">
					//<![CDATA[
					<!--
					$(document).ready(function() {
						
						/* init Tab */
						$("div.tabContent").hide();
						$("div#" + $("div.tabLables span.active").attr("tabTarget")).show();
						
						$("div.tabLables > span").click(function(){
							var $targetID = $(this).attr("tabTarget");
							
							$("div.tabLables span").removeClass("active");
							$(this).addClass("active");
							
							$("div.tabContent").not('[id="' + $targetID + '"]').hide();
							$("div.tabContent#" + $targetID).show();
						});
						
					});
					// -->
					//]]>
				</script>
				
				
				<div id="Search" class="tabContent">
					
					<form id="formSearch" onSubmit="javascript:return processVerfiyForm('formSearch');" class="formWrapper Transparent" method="post" action="<cfoutput>#buildURL('gradReview',passArgs)#</cfoutput>">
						<input type="hidden" name="TabID" value="labSearch" />
						
						<div class="label">
							<b>学号、中文名、国家、<br/>护照名、护照号</b>
							<input name="Keywords" id="Keywords" type="text" class="typeText" verification="required" maxlength="128" value="<cfoutput>#event.getArg('Keywords')#</cfoutput>" />
                                   <input name="cases" id="cases" type="radio" class="typeRadio" verification="required" maxlength="128" value="1" <cfif event.getArg('cases', '1') eq 1>checked="checked"</cfif> />大写显示
                                    <input name="cases" id="cases" type="radio" class="typeRadio" verification="required" maxlength="128" value="2" <cfif event.getArg('cases', '1') eq 2>checked="checked"</cfif>/>小写显示
                                     <input name="cases" id="cases" type="radio" class="typeRadio" verification="required" maxlength="128" value="3" <cfif event.getArg('cases', '1') eq 3>checked="checked"</cfif>/>正常显示
						</div>
						<hr/>
						<div class="lable">
							<input class="button1" type="submit" value="搜索" />
						</div>
					</form>
					
					<cfif rs_student.recordCount>

                              
							<cfset row = 0 />
                                   <table class="UIEditable">
                                        <thead>
                                             <tr>
                                                  <td width="18"></td>
                                                  <td>学号</td>
                                                  <td>中文名</td>
                                                  <td>性别</td>
                                                  <td>护照名</td>
                                                  <td>护照号</td>
                                                  <td>国籍</td>
                                                  <td align="center">学分指导教师</td>
                                                  <td width="18"></td>
                                             </tr>
                                        </thead>
                                        <tbody>
                                     <cfloop query="rs_student">
                                                  
                                                  <cfset row++ />
                                                  
                                                  <cfset structInsert(passArgs, "STU", rs_student.stu_id, true) />
                                                  <cfset structInsert(passArgs,"Keywords", keyword,true ) />
                                                  
                                                  <cfset propertyAdvice.parseProperty(rs_student.student_prop) />
                                                  
                                                  <tr class="editRows <cfif not propertyAdvice.getInSchool()>alertRow</cfif>">
                                                       <td class="index"><cfoutput>#row#</cfoutput></td>
                                                       <td><cfoutput>#replace(rs_student.stu_id,keyword,"<font color=red>" & keyword & "</font>")#</cfoutput></td>
                                                       <td><cfoutput>#replace(rs_student.stu_name,keyword,"<font color=red>" & keyword & "</font>")#</cfoutput></td>
                                                       <td><cfif rs_student.stu_sex eq "1">男<cfelse>女</cfif></td>
                                                       <td><cfoutput>#replace(rs_student.stu_name_english,keyword,"<font color=red>" & keyword & "</font>")#</cfoutput></td>
                                                       <td><cfoutput>#replace(rs_student.stu_idcard,keyword,"<font color=red>" & keyword & "</font>")#</cfoutput></td>
                                                       <td><cfoutput>#replace(rs_student.nationality,keyword,"<font color=red>" & keyword & "</font>")#</cfoutput></td>
                                                       <td align="center"><cfif rs_student.tch_name eq "">无<cfelse><cfoutput>#rs_student.tch_name#</cfoutput></cfif></td>
                                                       <td><a href="<cfoutput>#buildURL('gradReview', passArgs)#</cfoutput>" class="stat select"></a></td>
                                                  </tr>
                                             </cfloop>
                                        </tbody>
                                   </table>
                              
					
					</cfif>
					
				</div>
                    
                    <cfif len(studentId)>
				
					<div id="Form" class="tabContent">
						<cfset targetArgs = structNew()/>
                              
                              <cfset structInsert(targetArgs,"STU", studentId, true) /> 
						<div class="noticeBlock">
							<h3>本科生毕业审核信息</h3>
                                   <div class="operation">
                                 		<a class="uiButton" target="_blank" href="<cfoutput>#BuildURLToModule('markManager','totalScorePrint', targetArgs)#</cfoutput>"><i class="mrs img btnPrint"></i><span class="uiButtonText">查看成绩汇总表</span></a>
                                       
                                   </div>
						</div>
                              <br/>
					
						
						<form id="formCreate" onSubmit="javascript:return processVerfiyForm('formCreate');" class="formWrapper" method="post" action="<cfoutput>#buildURL('')#</cfoutput>">
					
							
							<div class="label">
								<b>学生信息</b>
								<input type="text" readonly="readonly" name="stuName" class="typeTextReadOnly" value="姓名：<cfoutput>#rs_studentEntity.stu_name#</cfoutput> （<cfoutput>#rs_studentEntity.stu_id#</cfoutput>）  -- <cfoutput>#rs_studentEntity.name#</cfoutput> " />
                                        <input type="text" readonly="readonly" name="stuName" style="width:550px" class="typeTextReadOnly" value="入学时间：<cfif rs_studentEntity.date_join neq ''><cfoutput>#dateJoinContent#</cfoutput><cfelse><cfoutput>#dateJoinContent#</cfoutput> (该生没有设置入学时间，按照该生第一个班级的年级默认计算)</cfif> " />
							</div>
<hr/>
							<div class="label">
								<b>毕业审核信息</b>
                                        <input type="text" readonly="readonly" name="stuName" class="typeTextReadOnly" value="总学分： <cfoutput>#courseCredit#</cfoutput> （必修课：<cfoutput>#courseMust#</cfoutput> , 选修课：<cfoutput>#courseSelect#</cfoutput> ）" />
                                        
                                         <input type="text" readonly="readonly" name="stuName" class="typeTextReadOnly" value="毕业论文：<cfoutput>#hasPaper#</cfoutput>" />
                                         <input type="text" readonly="readonly" name="stuName" class="typeTextReadOnly" value="实习课程：<cfoutput>#hasPrictice#</cfoutput>" />
                                         <input type="text" readonly="readonly" name="stuName" class="typeTextReadOnly" value="HSK成绩： <cfswitch expression="#rs_studentEntity.hsk_score#">
                                         		 <cfcase value="">无</cfcase>
                                                  <cfcase value="0">未通过</cfcase>
                                                  <cfcase value="1">HSK基础C级(分数等级:1级)</cfcase>
                                                  <cfcase value="2">HSK基础B级(分数等级:2级)</cfcase>
                                                  <cfcase value="3">HSK基础A级(分数等级:3级)</cfcase>
                                                  <!---<cfcase value="3">HSK初等C级(分数等级:3级)</cfcase>--->
                                                  <cfcase value="4">HSK初等B级(分数等级:4级)</cfcase>
                                                  <cfcase value="5">HSK初等A级(分数等级:5级)</cfcase>
                                                  <cfcase value="6">HSK中等C级(分数等级:6级)</cfcase>
                                                  <cfcase value="7">HSK中等B级(分数等级:7级)</cfcase>
                                                  <cfcase value="8">HSK中等A级(分数等级:8级)</cfcase>
                                                  <cfcase value="9">HSK高等C级(分数等级:9级)</cfcase>
                                                  <cfcase value="10">HSK高等B级(分数等级:10级)</cfcase>
                                                  <cfcase value="11">HSK高等A级(分数等级:11级)</cfcase>
                                           </cfswitch>" />
                                        <br/>
                                        
                                        <cfset creditNumTemp = 0/>
                                        <cfset creditMustTemp = 0/>
                                        <cfset creditSelectTemp = 0/>
                                        
                                        
                                        <cfloop from=1 to="#rs_courseType.recordCount#" index="rowIndex">
                                        	 
                                        	<cfset creditNum = courseTypeTable[rowIndex][1] + courseTypeTable[rowIndex][2] />
                                             
                                             <cfset creditNumTemp = creditNumTemp + creditNum />
                                             <cfset creditMustTemp = creditMustTemp + courseTypeTable[rowIndex][1] />
                                             <cfset creditSelectTemp = creditSelectTemp + courseTypeTable[rowIndex][2] />
                                             
                                        	<input type="text" readonly="readonly" name="stuName" class="typeTextReadOnly" value="<cfoutput>#rs_courseType["name"][rowIndex]#</cfoutput>：总学分：<cfoutput>#creditNum#</cfoutput>  (必修课：<cfoutput>#courseTypeTable[rowIndex][1]#</cfoutput> , 选修课：<cfoutput>#courseTypeTable[rowIndex][2]#</cfoutput>)" />
                                        </cfloop>
                                        
                                          <!----没有课程类别学分统计--->
                                        <cfset creditNo = courseCredit - creditNumTemp />
                                        <cfset creditMustNo = courseMust - creditMustTemp />
                                        <cfset creditSelectNo = courseSelect - creditSelectTemp />
                                        
                                       <input type="text" readonly="readonly" name="stuName" class="typeTextReadOnly" style="color:#F03" value="无课程类别：总学分：<cfoutput>#creditNo#</cfoutput>  (必修课：<cfoutput>#creditMustNo#</cfoutput> , 选修课：<cfoutput>#creditSelectNo#</cfoutput>)" />
								
								<cfif rs_courseType.recordCount><br/></cfif>
                                        
                                        <cfif rs_studentEntity.st_id eq '83'>
                                        
									<cfif result neq "" >
                                                  
                                                       <input type="text" readonly="readonly" name="stuName" class="typeTextReadOnly" value="班级必修课不及格课程：(2014-2015学年第1学期及之后成绩统计)" />
                                                       <cfloop list="#result#" index="rowIndex" delimiters="|||">
                                                            <input type="text" readonly="readonly" name="stuName" class="typeTextReadOnly" value="<cfoutput>#rowIndex#</cfoutput>" />
                                                       </cfloop>
                                                  
                                                  <cfelse>
                                                  	 <input type="text" readonly="readonly" name="stuName" class="typeTextReadOnly" value="班级必修课已全部及格 (2014-2015学年1学期及之后成绩统计)" />
                                             </cfif>
                                             
                                         </cfif>
                                        
                                        
							</div>
							
							
							
						</form>
					
					</div>
					
				</cfif>
				
			</div>
		</li>
	</ul>
</div>